[dbo].[BAEEventSetupGetFunctionsByGroupName]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEEventSetupGetFunctionsByGroupName

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@eventCode	varchar(15)	15
@groupName	varchar(25)	25

SQL Script

CREATE procedure [dbo].[BAEEventSetupGetFunctionsByGroupName] @eventCode varchar(15),
     @groupName varchar(25) as
SELECT * FROM EventSetupFunctionGroup
    INNER JOIN Product_Function on PRODUCT_CODE COLLATE database_default = EventCode + '/' + FunctionCode COLLATE database_default
    WHERE EventCode = @eventCode AND GroupName = @groupName AND WEB_ENABLED = 1 AND IS_GUEST_FUNCTION = 0
    ORDER BY FunctionOrder

GO

Uses

[dbo].[EventSetupFunctionGroup]
[dbo].[Product_Function]
dbo